SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for wb_admin
-- ----------------------------
DROP TABLE IF EXISTS `wb_admin`;
CREATE TABLE `wb_admin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL COMMENT '账号',
  `password` varchar(255) NOT NULL COMMENT '密码',
  `realname` varchar(125) NOT NULL DEFAULT '' COMMENT '姓名',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1:正常 0:禁用',
  `roles` varchar(255) NOT NULL DEFAULT '' COMMENT '角色',
  `last_ip` varchar(35) NOT NULL DEFAULT '' COMMENT '最后登录ip',
  `last_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='管理员表';

-- ----------------------------
-- Records of wb_admin
-- ----------------------------
BEGIN;
INSERT INTO `wb_admin` (`id`, `username`, `password`, `realname`, `status`, `roles`, `last_ip`, `last_time`, `create_time`, `update_time`, `delete_time`) VALUES (1, 'admin', '###70873e8580c9900986939611618d7b1e', 'admin', 1, '1', '221.218.28.86', 1670063025, 1669722421, 1670063025, 0);
INSERT INTO `wb_admin` (`id`, `username`, `password`, `realname`, `status`, `roles`, `last_ip`, `last_time`, `create_time`, `update_time`, `delete_time`) VALUES (2, 'test', '###14e1b600b1fd579f47433b88e8d85291', 'test', 1, '2', '49.156.46.15', 1669888044, 1669812141, 1669889521, 1669889521);
INSERT INTO `wb_admin` (`id`, `username`, `password`, `realname`, `status`, `roles`, `last_ip`, `last_time`, `create_time`, `update_time`, `delete_time`) VALUES (3, 'test', '###14e1b600b1fd579f47433b88e8d85291', 'test', 1, '2', '171.37.45.0', 1670047758, 1669889543, 1670047758, 0);
COMMIT;

-- ----------------------------
-- Table structure for wb_admin_roles
-- ----------------------------
DROP TABLE IF EXISTS `wb_admin_roles`;
CREATE TABLE `wb_admin_roles` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL DEFAULT '' COMMENT '角色名',
  `rules` text COMMENT '权限',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='角色表';

-- ----------------------------
-- Records of wb_admin_roles
-- ----------------------------
BEGIN;
INSERT INTO `wb_admin_roles` (`id`, `name`, `rules`, `create_time`, `update_time`, `delete_time`) VALUES (1, '超级管理员', '*', 0, 0, 0);
INSERT INTO `wb_admin_roles` (`id`, `name`, `rules`, `create_time`, `update_time`, `delete_time`) VALUES (2, '测试管理员', '3,2,4,7,9,20,1', 1669808076, 1669867512, 0);
COMMIT;

-- ----------------------------
-- Table structure for wb_admin_rules
-- ----------------------------
DROP TABLE IF EXISTS `wb_admin_rules`;
CREATE TABLE `wb_admin_rules` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上级菜单id',
  `path` varchar(125) NOT NULL DEFAULT '' COMMENT 'path',
  `name` varchar(125) NOT NULL DEFAULT '' COMMENT 'name 不可重复',
  `title` varchar(125) NOT NULL DEFAULT '' COMMENT '名称',
  `hide_menu` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0:显示 1:隐藏',
  `component` varchar(255) NOT NULL DEFAULT '' COMMENT '前端组件',
  `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序 大->小',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1:菜单 2:权限',
  `icon` varchar(125) NOT NULL DEFAULT '' COMMENT '图标',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COMMENT='菜单权限表';

-- ----------------------------
-- Records of wb_admin_rules
-- ----------------------------
BEGIN;
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (1, 0, '/dashboard', 'Dashboard', '首页', 0, '/dashboard/analysis/index', 0, 1, 'bx:bx-home', 0, 0, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (2, 0, '/system', 'System', '系统管理', 0, 'LAYOUT', 0, 1, 'ant-design:setting-outlined', 0, 1669786473, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (3, 2, 'sitesetting', 'SiteSetting', '网站设置', 1, '', 0, 1, '', 0, 1669861118, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (4, 2, 'rules', 'rules', '菜单管理', 0, '/wbadmin/system/menu/index', 0, 1, '', 0, 1669789091, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (5, 2, '123', '123', '测试菜单', 0, '123', 0, 2, 'ant-design:aliwangwang-outlined', 1669788048, 1669789093, 1669789093);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (6, 0, '1233333', '1231', '菜单名称', 0, '', 0, 2, '', 1669788279, 1669789096, 1669789096);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (7, 2, 'role', 'role', '角色管理', 0, '/wbadmin/system/role/index', 0, 1, '', 1669791790, 1669803192, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (8, 10, 'admin/rules/addMenu', '', '添加菜单', 0, '', 0, 2, '', 1669793213, 1669817613, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (9, 2, 'admin', 'admin', '管理员管理', 0, '/wbadmin/system/account/index', 0, 1, '', 1669810075, 1669810075, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (10, 2, '', '', '权限', 0, '', 0, 2, '', 1669815175, 1669815175, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (11, 10, 'admin/rules/editMenu', '', '编辑菜单', 0, '', 0, 2, '', 1669817411, 1669817619, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (12, 0, '123', '123', '123', 0, '123123', 0, 1, '', 1669818493, 1669818675, 1669818675);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (13, 10, 'admin/rules/delMenu', '', '菜单删除', 0, '', 0, 2, '', 1669818698, 1669818828, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (14, 10, 'admin/rules/delRole', '', '删除角色', 0, '', 0, 2, '', 1669818752, 1669818752, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (15, 10, 'admin/rules/addRole', '', '添加角色', 0, '', 0, 2, '', 1669818783, 1669818783, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (16, 10, 'admin/rules/editRole', '', '编辑角色', 0, '', 0, 2, '', 1669818822, 1669818822, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (17, 10, 'admin/rules/addAdmin', '', '添加管理员', 0, '', 0, 2, '', 1669818904, 1669818904, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (18, 10, 'admin/rules/editAdmin', '', '编辑管理员', 0, '', 0, 2, '', 1669818928, 1669818928, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (19, 10, 'admin/rules/delAdmin', '', '删除管理员', 0, '', 0, 2, '', 1669818945, 1669818945, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (20, 2, 'password', 'password', '修改密码', 0, '/wbadmin/system/password/index', 0, 1, '', 1669855785, 1669855845, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (21, 10, 'admin/index/getRequestLog', '', '获取请求记录列表', 0, '', 0, 2, '', 1670124649, 1670124649, 0);
INSERT INTO `wb_admin_rules` (`id`, `pid`, `path`, `name`, `title`, `hide_menu`, `component`, `sort`, `type`, `icon`, `create_time`, `update_time`, `delete_time`) VALUES (22, 10, 'admin/index/clearRequestLog', '', '清空请求记录', 0, '', 0, 2, '', 1670124679, 1670124679, 0);
COMMIT;

-- ----------------------------
-- Table structure for wb_option
-- ----------------------------
DROP TABLE IF EXISTS `wb_option`;
CREATE TABLE `wb_option` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(125) NOT NULL COMMENT '配置name',
  `option_value` text COMMENT '配置内容',
  `delete_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='配置表';

-- ----------------------------
-- Records of wb_option
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for wb_request_log
-- ----------------------------
DROP TABLE IF EXISTS `wb_request_log`;
CREATE TABLE `wb_request_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(26) NOT NULL DEFAULT '',
  `method` varchar(15) NOT NULL DEFAULT '',
  `fullurl` varchar(255) NOT NULL DEFAULT '',
  `app` varchar(26) NOT NULL DEFAULT '',
  `controller` varchar(55) NOT NULL DEFAULT '',
  `action` varchar(55) NOT NULL DEFAULT '',
  `route` varchar(125) NOT NULL DEFAULT '' COMMENT '路由',
  `times` mediumint(7) unsigned NOT NULL DEFAULT '0' COMMENT '请求耗时 ms',
  `exception` varchar(555) NOT NULL DEFAULT '' COMMENT '异常数据',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COMMENT='请求记录表';

-- ----------------------------
-- Records of wb_request_log
-- ----------------------------
BEGIN;
INSERT INTO `wb_request_log` (`id`, `ip`, `method`, `fullurl`, `app`, `controller`, `action`, `route`, `times`, `exception`, `create_time`) VALUES (17, '221.218.28.86', 'GET', 'test2.breaverdigital.com/admin/index/clearRequestLog', 'admin', 'IndexController', 'clearRequestLog', '', 15, '', 1670124584);
INSERT INTO `wb_request_log` (`id`, `ip`, `method`, `fullurl`, `app`, `controller`, `action`, `route`, `times`, `exception`, `create_time`) VALUES (18, '221.218.28.86', 'POST', 'test2.breaverdigital.com/admin/index/getRequestLog', 'admin', 'IndexController', 'getRequestLog', '', 14, '', 1670124590);
INSERT INTO `wb_request_log` (`id`, `ip`, `method`, `fullurl`, `app`, `controller`, `action`, `route`, `times`, `exception`, `create_time`) VALUES (19, '221.218.28.86', 'GET', 'test2.breaverdigital.com/admin/Rules/getList?_t=1670124616704', 'admin', 'RulesController', 'getList', '', 2, '', 1670124617);
INSERT INTO `wb_request_log` (`id`, `ip`, `method`, `fullurl`, `app`, `controller`, `action`, `route`, `times`, `exception`, `create_time`) VALUES (20, '221.218.28.86', 'GET', 'test2.breaverdigital.com/admin/Rules/getList?_t=1670124620898', 'admin', 'RulesController', 'getList', '', 1, '', 1670124621);
INSERT INTO `wb_request_log` (`id`, `ip`, `method`, `fullurl`, `app`, `controller`, `action`, `route`, `times`, `exception`, `create_time`) VALUES (21, '221.218.28.86', 'POST', 'test2.breaverdigital.com/admin/Rules/addMenu', 'admin', 'RulesController', 'addMenu', '', 7, '', 1670124649);
INSERT INTO `wb_request_log` (`id`, `ip`, `method`, `fullurl`, `app`, `controller`, `action`, `route`, `times`, `exception`, `create_time`) VALUES (22, '221.218.28.86', 'GET', 'test2.breaverdigital.com/admin/Rules/getList?_t=1670124649790', 'admin', 'RulesController', 'getList', '', 5, '', 1670124650);
INSERT INTO `wb_request_log` (`id`, `ip`, `method`, `fullurl`, `app`, `controller`, `action`, `route`, `times`, `exception`, `create_time`) VALUES (23, '221.218.28.86', 'GET', 'test2.breaverdigital.com/admin/Rules/getList?_t=1670124654006', 'admin', 'RulesController', 'getList', '', 1, '', 1670124654);
INSERT INTO `wb_request_log` (`id`, `ip`, `method`, `fullurl`, `app`, `controller`, `action`, `route`, `times`, `exception`, `create_time`) VALUES (24, '221.218.28.86', 'POST', 'test2.breaverdigital.com/admin/Rules/addMenu', 'admin', 'RulesController', 'addMenu', '', 5, '', 1670124679);
INSERT INTO `wb_request_log` (`id`, `ip`, `method`, `fullurl`, `app`, `controller`, `action`, `route`, `times`, `exception`, `create_time`) VALUES (25, '221.218.28.86', 'GET', 'test2.breaverdigital.com/admin/Rules/getList?_t=1670124679344', 'admin', 'RulesController', 'getList', '', 5, '', 1670124679);
INSERT INTO `wb_request_log` (`id`, `ip`, `method`, `fullurl`, `app`, `controller`, `action`, `route`, `times`, `exception`, `create_time`) VALUES (26, '221.218.28.86', 'GET', 'test2.breaverdigital.com/admin/index/exportRequestLog', 'admin', 'IndexController', 'exportRequestLog', '', 4, '', 1670125375);
INSERT INTO `wb_request_log` (`id`, `ip`, `method`, `fullurl`, `app`, `controller`, `action`, `route`, `times`, `exception`, `create_time`) VALUES (27, '221.218.28.86', 'GET', 'test2.breaverdigital.com/admin/index/exportRequestLog', 'admin', 'IndexController', 'exportRequestLog', '', 49, '', 1670125383);
COMMIT;

-- ----------------------------
-- Table structure for wb_upload_file
-- ----------------------------
DROP TABLE IF EXISTS `wb_upload_file`;
CREATE TABLE `wb_upload_file` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(150) NOT NULL DEFAULT '',
  `origin_name` varchar(255) NOT NULL DEFAULT '' COMMENT '原始文件名',
  `save_name` varchar(255) NOT NULL DEFAULT '' COMMENT '保存文件名',
  `save_path` varchar(255) NOT NULL DEFAULT '' COMMENT '保存的绝对路径',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '访问路径',
  `unique_id` varchar(255) NOT NULL DEFAULT '' COMMENT '唯一id',
  `size` int(11) NOT NULL DEFAULT '0' COMMENT '大小(字节)',
  `mime_type` varchar(50) NOT NULL DEFAULT '' COMMENT '类型',
  `extension` varchar(30) NOT NULL DEFAULT '' COMMENT '后缀',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='文件上传记录表';

-- ----------------------------
-- Records of wb_upload_file
-- ----------------------------
BEGIN;
INSERT INTO `wb_upload_file` (`id`, `key`, `origin_name`, `save_name`, `save_path`, `url`, `unique_id`, `size`, `mime_type`, `extension`, `create_time`, `update_time`, `delete_time`) VALUES (3, 'file', '1669869294208.jpg', 'afdc618c71f1a9f2657d3eb9d1613dee9781cb49.jpg', 'upload/20221203/afdc618c71f1a9f2657d3eb9d1613dee9781cb49.jpg', 'http://test2.breaverdigital.com/upload/20221203/afdc618c71f1a9f2657d3eb9d1613dee9781cb49.jpg', 'afdc618c71f1a9f2657d3eb9d1613dee9781cb49', 141830, 'image/jpeg', 'jpg', 1670062329, 1670062329, 0);
INSERT INTO `wb_upload_file` (`id`, `key`, `origin_name`, `save_name`, `save_path`, `url`, `unique_id`, `size`, `mime_type`, `extension`, `create_time`, `update_time`, `delete_time`) VALUES (4, 'file1', '1669869435907.jpg', '4db5091606e6ca6e4b69847b158775f1ee9fb1b3.jpg', 'upload/20221203/4db5091606e6ca6e4b69847b158775f1ee9fb1b3.jpg', 'http://test2.breaverdigital.com/upload/20221203/4db5091606e6ca6e4b69847b158775f1ee9fb1b3.jpg', '4db5091606e6ca6e4b69847b158775f1ee9fb1b3', 314068, 'image/jpeg', 'jpg', 1670062571, 1670062571, 0);
INSERT INTO `wb_upload_file` (`id`, `key`, `origin_name`, `save_name`, `save_path`, `url`, `unique_id`, `size`, `mime_type`, `extension`, `create_time`, `update_time`, `delete_time`) VALUES (5, 'file2', '1669869378530.jpg', 'f9aa6a8f71f352aa99779a81586f79d31d3cb0e3.jpg', 'upload/20221203/f9aa6a8f71f352aa99779a81586f79d31d3cb0e3.jpg', 'http://test2.breaverdigital.com/upload/20221203/f9aa6a8f71f352aa99779a81586f79d31d3cb0e3.jpg', 'f9aa6a8f71f352aa99779a81586f79d31d3cb0e3', 232087, 'image/jpeg', 'jpg', 1670062571, 1670062571, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
